Graphical Designer

You can add transformation and lookup details to a mapping specification on the Graphical Designer tab.

Adding transformation details involves setting up:

  • Business rule
  • Extended business rule transformation

Ensure that you define business rules under the Transformations node for the same ETL Option as the Project ETL. For more information on defining business rules, refer to the Defining Transformations section.

Adding lookup details involves setting up:

  • Trans lookup condition
  • Lookup reference column
  • Lookup on

Ensure that you scan the required table in the Metadata Manager to set trans lookup condition.

Adding Transformation Details

To add business rules graphically, follow these steps:

  1. Click the Graphical Designer tab.
  2. Click Icon Edit.

    3. You can now edit the mapping specification graphically.

  3. Click the mapping link of the required column and expand the Properties pane.
  4. Expand the Transformation Details pane.
    5. Mapped Graphically Transformations
  5. Double-click the Value cell for Business Rule and select the required value.
  6. Click Icon Save Mapping Specification.

    7. The business rule is added to the mapping link. You can add business rules for multiple mapping links.

To add extended business rule transformations graphically, follow these steps:

  1. On the Graphical Designer tab, Click Icon Transformation Editor.

    2. The available options appear.

    Graphical Designer Extended Transformation
  2. Select the Extended Business Rule check box.
  3. Click the mapping link of the required column and expand the Transformation Details pane.
    4. Mapped Graphically Transformations
  4. Double-click the Value cell for Extended Business Rule Transformation.

    5. The Extended Transformation Rule Editor page appears.

    Extended Transformation Rule Editor

  5. Select the pseudocode based on the Project ETL.

    6. For example, if the Project ETL is Informatica then select Informatica Pseudocode.

    Extended Transformation Rule Editor Page

  6. Press Ctrl + Space keys.

    7. The available transformations appear.

    Ctrl Space to Select Br

    If the required transformation is not available in the list, use Icon Create Transformations to create and update the transformations list.

  7. Double-click the required transformation.

    8. You can use Icon Replace Transformation Name to replace transformation name with pseudocode.

  8. Click Icon Save User.

    9. The extended business rule transformation is added to the mapping link. You can add extended business rule transformations to multiple mapping links.

Adding Lookup Details

To add lookup details graphically, follow these steps:

  1. On the Graphical Designer tab, click the mapping link of the required column and expand the Properties pane.
  2. Expand the Lookup Details pane.
    3. Mapped Graphically Lookup
  3. Drag the required table from the Metadata Tree View pane and drop it for Trans Lookup Condition.
    4. Trans Lookup Condition Graphically

    Once trans lookup condition is set, you can add lookup reference column and lookup on.

    To add lookup reference column, double-click the cell for Lookup Reference Column and select the required option.

    Trans Lookup Condition

    To add lookup on, double-click the cell against Lookup On and select the required option.

  4. Click Icon Save Mapping Specification.

    5. The lookup details are added to the mapping specification. You can add lookup details for multiple mapping links.